package com.atguigu.edu.mapper;

import com.atguigu.edu.bean.TradeProvinceOrderAmount;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TradeStatsMapper {

    // TODO: 2024/10/22 1.当日各省份下单金额
    @Select("select\n" +
            "province_name,\n" +
            "sum(order_amount)\n" +
            "from\n" +
            "dws_trade_sku_order_window partition par#{date}\n" +
            "group bi\n" +
            "province_name")
    List<TradeProvinceOrderAmount> selectProvinceAmount(Integer date);
}
